Which types of subqueries does Snowflake support? (Choose two.)
Answer : AB
Which Snowflake data governance feature can support auditing when a user query reads column data?
Answer : A
Which command can be used to list all network policies available in an account?
Answer : D
Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?
Answer : C
What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
Answer : C
What are the primary authentication methods that Snowflake supports for securing REST API interactions? (Choose two.)
Answer : AB
Which operation can be performed on Snowflake external tables?
Answer : B
What does the LATERAL modifier for the FLATTEN function do?
Answer : C
Which function can be used with the COPY INTO <location> statement to convert rows from a relational table to a single VARIANT column, and to unload rows into a JSON file?
Answer : C
Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
Answer : D
In the Data Exchange, who can get or request data from the listings? (Choose two.)
Answer : AD
In which hierarchy is tag inheritance possible?
Answer : D
Which Snowflake privilege is required on a pipe object to pause or resume pipes?
Answer : A
What happens when a suspended virtual warehouse is resized in Snowflake?
Answer : C
Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?
Answer : B
Have any questions or issues ? Please dont hesitate to contact us